汾 v1.1  2011-12-27

1ĹܣûͨһԼ˺
2ʵ˺̨ǰ̨ҳĿƣԱǰ̨ҳĵĹ
3ʵתصĹ
4ʵȶͼİ
5ʵ˸ǳ޸ʱļ
6ʵֵ
7޸˵¼IE7ʽλ⡣
8עеûעʱǳƵļ
9޸ҳҵĹע껮ȥ
10޸ƵеӲֵ֧⡣
11޸ͼƬݿ쳣
12ҳ ťͼƬ޸Ϊ
13JSȡļ
14ҳݼص쳣
15ʵֹעĹ


ݿĽṹģ
---------------------1޸û(Dd_User)ֶ---------------------------
aû(Dd_User)һֶΣ
	User_isSet   int()

bֶ(User_isSet)ĬֵΪ0
cִи£update Dd_User set User_isSet=0

----------------------2ӹע-----------------------------------------
USE [HaTeam_Dd]
GO

/****** Object:  Table [dbo].[Dd_Attention]    Script Date: 12/25/2011 15:21:03 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Dd_Attention](
	[Attention_ID] [int] IDENTITY(1,1) NOT NULL,
	[Attention_UerID] [int] NULL,
	[Attented_By_user] [int] NULL,
	[Attention_BlackList] [int] NULL,
	[Attention_Guid] [nchar](1) NULL,
	[Attention_Datetime] [datetime] NULL,
	[Attention_UpDatetime] [datetime] NULL,
	[Attention_Verify] [int] NULL,
	[Attention_Lock] [int] NULL,
	[Attention_State] [int] NULL,
	[Attention_Delete] [int] NULL,
	[Attention_Count] [int] NULL,
	[Attention_Order] [int] NULL,
	[Attention_Remark] [ntext] NULL,
PRIMARY KEY CLUSTERED 
(
	[Attention_ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'͵˵ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dd_Attention', @level2type=N'COLUMN',@level2name=N'Attention_UerID'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ע˵ģɣ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dd_Attention', @level2type=N'COLUMN',@level2name=N'Attented_By_user'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dd_Attention', @level2type=N'COLUMN',@level2name=N'Attention_BlackList'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ݿΨһԱʶ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dd_Attention', @level2type=N'COLUMN',@level2name=N'Attention_Guid'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ʱ(¼Ĵʱ)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dd_Attention', @level2type=N'COLUMN',@level2name=N'Attention_Datetime'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ʱ(¼޸ʱ)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dd_Attention', @level2type=N'COLUMN',@level2name=N'Attention_UpDatetime'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ƿ(0δ,1)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dd_Attention', @level2type=N'COLUMN',@level2name=N'Attention_Verify'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ƿ(0δ,1)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dd_Attention', @level2type=N'COLUMN',@level2name=N'Attention_Lock'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'״̬(0,1)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dd_Attention', @level2type=N'COLUMN',@level2name=N'Attention_State'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ƿɾ(0δɾ,1ɾ)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dd_Attention', @level2type=N'COLUMN',@level2name=N'Attention_Delete'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ʹô(¼ʹô)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dd_Attention', @level2type=N'COLUMN',@level2name=N'Attention_Count'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¼(¼ʾ˳)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dd_Attention', @level2type=N'COLUMN',@level2name=N'Attention_Order'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ע˵Ϣ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dd_Attention', @level2type=N'COLUMN',@level2name=N'Attention_Remark'
GO

--------------------------3޸ͼview_tables---------------------

USE [HaTeam_Dd]
GO

/****** Object:  View [dbo].[view_tables]    Script Date: 12/25/2011 15:57:50 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


alter view [dbo].[view_tables]
as
select Text_ID TypeID,User_ID,Text_Title Title,Text_Content Content,Text_Empty Discript,Text_Tag Lable,Text_Fever Fever,Text_OriginId OriginID,Text_Datetime Datetime, Text_Order Orders from Dd_Text where Text_Delete=0  
union all 
select Picture_ID,User_ID,Picture_Address,Picture_Discription,Picture_Empty,Picture_Tag,Picture_Fever,Picture_OriginId OriginID,Picture_Datetime,Picture_Order from Dd_Picture  where Picture_Delete=0
union all
select Link_ID,User_ID,Link_Title,Link_Address,Link_Description,Link_Tag,Link_Fever,Link_OriginId OriginID,Link_Datetime,Link_Order from Dd_Link where Link_Delete=0
union all
select Video_ID,User_ID,Video_Radiourl,Video_Imageurl,Video_Description,Video_Tag,Video_Fever,Video_OriginId OriginID,Video_Datetime,Video_Order from Dd_Video where Video_Delete=0



GO

-----------------------------4Ĭֵ---------------------------------
Ӧ(Dd_Reply) : Reply_Delete=0
ϲ(Dd_Like) : Like_Delete=0
תر(Dd_Reprint): Reprint_Delete=0

ִв
update Dd_Reply set Reply_Delete=0 
update Dd_Like set Like_Delete=0
update Dd_Reprint set Reprint_Delete=0



